﻿if exists (select 1
            from  sysobjects
           where  id = object_id('GXBZ_EMR_ZYYZ')
            and   type = 'U')
   drop table GXBZ_EMR_ZYYZ
go

/*==============================================================*/
/* Table: GXBZ_EMR_ZYYZ                                         */
/*==============================================================*/
create table GXBZ_EMR_ZYYZ (
   JZLSH                varchar(64)          not null,
   XGBZ                 varchar(1)           not null,
   GRJBXXBSH            varchar(64)          not null,
   CXJMJKDABH           varchar(17)          not null,
   YLJGDM               varchar(22)          null,
   YLJGMC               varchar(70)          null,
   CJSJ                 datetime             null,
   XDRGH                varchar(64)          null,
   XDRXM                varchar(30)          null,
   WDGLJGDM             varchar(22)          null,
   WDGLJGMC             varchar(70)          null,
   JYSJ                 datetime             null,
   BCHDM                varchar(20)          null,
   BCHMC                varchar(100)         null,
   BFHDM                varchar(20)          null,
   BFHMC                varchar(100)         null,
   BQHDM                varchar(20)          null,
   BQHMC                varchar(100)         null,
   ZXKSBM               varchar(64)          null,
   ZXKSMC               varchar(32)          null,
   TZ                   decimal(6,2)         null,
   YZLBDM               varchar(50)          null,
   YZLBMC               varchar(100)         null,
   YZXMLXDM             varchar(50)          null,
   YZXMLXMC             varchar(100)         null,
   YZZXSJ               datetime             null,
   YZZZSJ               datetime             null,
   YZXMNRMS             varchar(1024)        null,
   YZXDSJ               datetime             null,
   XDKSBM               varchar(64)          null,
   XDKSMC               varchar(32)          null,
   SHSJ                 datetime             null,
   SHRGH                varchar(64)          null,
   SHRXM                varchar(30)          null,
   HDSJ                 datetime             null,
   HDHSGH               varchar(64)          null,
   HDHSXM               varchar(30)          null,
   TZYZZGH              varchar(64)          null,
   TZYZZXM              varchar(30)          null,
   YZQXSJ               datetime             null,
   YZQXZGH              varchar(64)          null,
   YZQXZXM              varchar(30)          null,
   YZBZ                 varchar(1024)        null,
   YZZXZT               varchar(50)          null,
   ZXRGH                varchar(64)          null,
   ZXRXM                varchar(30)          null,
   DZSQDBH              varchar(100)         null,
   CFYPZH               varchar(64)          null,
   MJ                   varchar(16)          not null,
   TBRQ                 datetime             not null,
   SCZT                 varchar(1)           not null,
   CS_JYBZ              int                  not null,
   SCSJ                 datetime             not null,
   constraint PK_GXBZ_EMR_ZYYZ primary key (JZLSH, XGBZ)
)
go
